Climbing Route Totals @ Mt. Rainier National Park
Provisional data only: Guide services were NOT in included in 2002-2005
public data.
This page is currently being updated: 2015-07-26
Records paste well into MS Excel.
Records only go back to 2006.
Route |
Total |
mysql_connect('mountrainierclimbing.dot5hostingmysql.com', 'yearlytotals', 'yearlytotals');
mysql_select_db('yearlytotals');
$year=$_GET['year'];
$s="SELECT route, SUM(size) AS s FROM moraclimbing WHERE date>='$year-01-01' AND date<='$year-12-31' GROUP BY route ORDER BY s DESC";
echo ("
");
$total=0;
$r=mysql_query($s);
while($rows=mysql_fetch_array($r)){
if($rows['route']==''){$rows['route']='(Not Specified)';}
?>
echo $rows['route']; ?> |
echo $rows['s']; $total=$total+$rows['s']; ?> |
};
?>
Total Climbers: |
echo $total; ?> |